PUBLIC MARKS from "Xavier Lacot" with tag mysql

Using a MySQL "HandlerSocket" plugin, Yoshinori Matsunobu achieved a 750K requests per second on a normal box, which was slightly more performant than with a memcached server

A nifty and very usable MySQL desktop client for OSX.

Maatkit is a package which contains high-quality command-line tools for MySQL. The tools enable power users of MySQL to do their work more safely and quickly by relying on tested software instead of scripting things themselves. The toolkit includes functionality such as table checksums, a query profiler, and a visual EXPLAIN tool, a multiprocess version of mysqldump.

The MySQL Workbench Doctrine Plugin is a plugin developed for MySQL Workbench which is a tool for developing MySQL databases with a graphical interface. Even developing MySQL databases with Workbench you can use the .yml output for usage with every database supported by doctrine.

"Jet Profiler for MySQL is real-time query performance and diagnostics tool for the MySQL database server". I love the Query ratings feature and the live query observation - should replace the weak use of MySQL proxy.

Sphinx is a standalone search engine, meant to provide fast, size-efficient and relevant fulltext search functions to other applications. Sphinx was specially designed to integrate well with SQL databases and scripting languages. Currently built-in data sources support fetching data either via direct connection to MySQL or PostgreSQL, or using XML pipe mechanism (a pipe to indexer in special XML-based format which Sphinx recognizes).

Consider the following pseudo-code: $nid = node_save($data); $node = node_load($nid); Because node_save() executes a mutator query (an INSERT or UPDATE statement) is has to be executed on the master, so the master can propagate the changes to the slaves. Because node_load() uses a read-only query, it can go to the master or any of the available slaves. Because of the lack of synchronization between master and slaves, there is one obvious caveat: when we execute node_load() the slaves might not have been updated.

This tutorial should show a decent way to send data in a database to and from flex to php using json.

This is a project for the MySQL Filesystem storage engine. It translates normal files on your server into relational tables inside of MySQL.

If you read the MySQL manual you might have seen the ORDER BY RAND() to randomize the the rows and using the LIMIT 1 to just take one of the rows.

Securing plain text passwords in MySQL is NEVER a good idea. As a DBA you should take great care in protecting the users' information. Fortunately MySQL provides you with several options to protect passwords.

Quelques conseils pour améliorer les perfs InnoDB

ARC facilitates the integration of RDF and SPARQL functionality in PHP/MySQL-driven frameworks.

How to build a linux + lighhttpd + PHP5 + MySQL platform over a simple Mactor Shared Storage network disk.

Un système de mails complet avec des utilisateurs virtuels gérés par MySQL